First round interview question (chain sys)
1.Sumof salary from department.
2.what is dml
3.diff b/w trancate and delete.
4.inner query and sub query.
5.sub query and it's types.
6.diff b/w view and mview .
7.inline view.
8.procedure and functions
9.types of exceptional handling .
10.what  is Unprefined exceptions .when will raise the exception .
Give any Error code?
11.what is gtt ?
12.what is collections and its types .
13.triggers and events and types.
14.cursors and its types .
15 .give syntax for nested table in collection.
16.dif b/w  in ,out ,in/out
  17 .give syntax for triggers .(eg)